Pandas Profiling Report: Hourly Data

Dataset statistics

Number of variables	12
Number of observations	337
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	31.7 KiB
Average record size in memory	96.4 B

Variable types

NUM	11
DATE	1

Reproduction

Analysis started	2020-06-25 19:24:39.429504
Analysis finished	2020-06-25 19:24:51.843832
Duration	12.41 seconds
Version	pandas-profiling v2.8.0
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

Warnings

`PM2.5` is highly correlated with `PM1` and 1 other fields	High correlation
`PM1` is highly correlated with `PM2.5` and 1 other fields	High correlation
`PM10` is highly correlated with `PM1` and 1 other fields	High correlation
`Time` has unique values	Unique
`PM1` has unique values	Unique
`PM2.5` has unique values	Unique
`H2S` has 303 (89.9%) zeros	Zeros

Time
Date

UNIQUE

Distinct count	337
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	2.8 KiB

Minimum	2020-05-26 08:00:00
Maximum	2020-06-09 08:00:00

Histogram

Histogram

Ozone
Real number (ℝ_≥0)

Distinct count	50
Unique (%)	14.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.34620178041543026
Minimum	0.17
Maximum	0.68
Zeros	0
Zeros (%)	0.0%
Memory size	2.8 KiB

Quantile statistics

Minimum	0.17
5-th percentile	0.18
Q1	0.2
median	0.34
Q3	0.44
95-th percentile	0.61
Maximum	0.68
Range	0.51
Interquartile range (IQR)	0.24

Descriptive statistics

Standard deviation	0.1361627427
Coefficient of variation (CV)	0.3933045709
Kurtosis	-0.7969592877
Mean	0.3462017804
Median Absolute Deviation (MAD)	0.13
Skewness	0.3971906049
Sum	116.67
Variance	0.0185402925

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0.18	38	11.3%
0.19	29	8.6%
0.2	21	6.2%
0.41	15	4.5%
0.21	14	4.2%
0.33	12	3.6%
0.36	11	3.3%
0.45	11	3.3%
0.47	10	3.0%
0.43	10	3.0%
0.39	9	2.7%
0.4	9	2.7%
0.34	9	2.7%
0.26	9	2.7%
0.44	8	2.4%
0.38	8	2.4%
0.32	8	2.4%
0.48	8	2.4%
0.35	6	1.8%
0.27	6	1.8%
0.49	6	1.8%
0.42	5	1.5%
0.56	5	1.5%
0.51	5	1.5%
0.52	5	1.5%
Other values (25)	60	17.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.17	2	0.6%
0.18	38	11.3%
0.19	29	8.6%
0.2	21	6.2%
0.21	14	4.2%
0.22	4	1.2%
0.23	2	0.6%
0.24	2	0.6%
0.25	1	0.3%
0.26	9	2.7%

Value	Count	Frequency (%)
0.68	1	0.3%
0.67	1	0.3%
0.66	2	0.6%
0.65	2	0.6%
0.64	3	0.9%
0.63	2	0.6%
0.62	3	0.9%
0.61	4	1.2%
0.6	2	0.6%
0.59	1	0.3%

H2S
Real number (ℝ_≥0)

ZEROS

Distinct count	23
Unique (%)	6.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4.759643916913947e-05
Minimum	0.0
Maximum	0.002
Zeros	303
Zeros (%)	89.9%
Memory size	2.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0.000186
Maximum	0.002
Range	0.002
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.0002311098553
Coefficient of variation (CV)	4.855612297
Kurtosis	39.46303085
Mean	4.759643917e-05
Median Absolute Deviation (MAD)	0
Skewness	6.009698599
Sum	0.01604
Variance	5.341176523e-08

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	303	89.9%
2e-05	7	2.1%
3e-05	5	1.5%
0.0008	2	0.6%
0.00102	2	0.6%
0.00012	1	0.3%
0.00033	1	0.3%
4e-05	1	0.3%
0.00027	1	0.3%
0.00021	1	0.3%
0.002	1	0.3%
0.00128	1	0.3%
0.00018	1	0.3%
0.00025	1	0.3%
0.00091	1	0.3%
0.00028	1	0.3%
0.00063	1	0.3%
5e-05	1	0.3%
0.0009	1	0.3%
0.00098	1	0.3%
0.00017	1	0.3%
0.00153	1	0.3%
0.00198	1	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	303	89.9%
2e-05	7	2.1%
3e-05	5	1.5%
4e-05	1	0.3%
5e-05	1	0.3%
0.00012	1	0.3%
0.00017	1	0.3%
0.00018	1	0.3%
0.00021	1	0.3%
0.00025	1	0.3%

Value	Count	Frequency (%)
0.002	1	0.3%
0.00198	1	0.3%
0.00153	1	0.3%
0.00128	1	0.3%
0.00102	2	0.6%
0.00098	1	0.3%
0.00091	1	0.3%
0.0009	1	0.3%
0.0008	2	0.6%
0.00063	1	0.3%

VOC
Real number (ℝ_≥0)

Distinct count	138
Unique (%)	40.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.18356083086053415
Minimum	0.069
Maximum	2.118
Zeros	0
Zeros (%)	0.0%
Memory size	2.8 KiB

Quantile statistics

Minimum	0.069
5-th percentile	0.082
Q1	0.13
median	0.146
Q3	0.171
95-th percentile	0.3726
Maximum	2.118
Range	2.049
Interquartile range (IQR)	0.041

Descriptive statistics

Standard deviation	0.1816832916
Coefficient of variation (CV)	0.9897715694
Kurtosis	58.77772079
Mean	0.1835608309
Median Absolute Deviation (MAD)	0.021
Skewness	6.827450713
Sum	61.86
Variance	0.03300881846

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0.131	9	2.7%
0.142	8	2.4%
0.13	8	2.4%
0.146	8	2.4%
0.173	8	2.4%
0.134	8	2.4%
0.14	7	2.1%
0.17	7	2.1%
0.168	7	2.1%
0.127	6	1.8%
0.135	6	1.8%
0.171	6	1.8%
0.129	6	1.8%
0.161	6	1.8%
0.132	6	1.8%
0.165	5	1.5%
0.155	5	1.5%
0.153	5	1.5%
0.141	5	1.5%
0.144	5	1.5%
0.143	5	1.5%
0.145	5	1.5%
0.185	5	1.5%
0.138	5	1.5%
0.083	4	1.2%
Other values (113)	182	54.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.069	1	0.3%
0.07	1	0.3%
0.071	1	0.3%
0.072	1	0.3%
0.074	1	0.3%
0.075	2	0.6%
0.077	1	0.3%
0.078	2	0.6%
0.079	1	0.3%
0.08	2	0.6%

Value	Count	Frequency (%)
2.118	1	0.3%
1.782	1	0.3%
1.138	1	0.3%
0.92	1	0.3%
0.776	1	0.3%
0.763	1	0.3%
0.716	1	0.3%
0.711	1	0.3%
0.673	1	0.3%
0.64	1	0.3%

CO2
Real number (ℝ_≥0)

Distinct count	127
Unique (%)	37.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	383.63204747774483
Minimum	305
Maximum	773
Zeros	0
Zeros (%)	0.0%
Memory size	2.8 KiB

Quantile statistics

Minimum	305
5-th percentile	326.8
Q1	338
median	354
Q3	388
95-th percentile	604.6
Maximum	773
Range	468
Interquartile range (IQR)	50

Descriptive statistics

Standard deviation	84.93058044
Coefficient of variation (CV)	0.2213855203
Kurtosis	7.454376748
Mean	383.6320475
Median Absolute Deviation (MAD)	20
Skewness	2.711602024
Sum	129284
Variance	7213.203494

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
331	11	3.3%
355	10	3.0%
337	9	2.7%
334	9	2.7%
340	9	2.7%
338	9	2.7%
347	8	2.4%
342	8	2.4%
341	7	2.1%
353	6	1.8%
354	6	1.8%
332	6	1.8%
374	6	1.8%
351	5	1.5%
388	5	1.5%
346	5	1.5%
363	5	1.5%
343	5	1.5%
359	5	1.5%
345	5	1.5%
344	5	1.5%
336	5	1.5%
329	5	1.5%
377	4	1.2%
335	4	1.2%
Other values (102)	175	51.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
305	1	0.3%
309	1	0.3%
313	1	0.3%
314	2	0.6%
317	2	0.6%
320	1	0.3%
323	2	0.6%
324	2	0.6%
325	3	0.9%
326	2	0.6%

Value	Count	Frequency (%)
773	1	0.3%
771	1	0.3%
762	1	0.3%
740	1	0.3%
734	1	0.3%
715	1	0.3%
711	1	0.3%
694	1	0.3%
685	1	0.3%
650	1	0.3%

PM1
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct count	337
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5.153720650548535
Minimum	1.2273166666666666
Maximum	23.511551724137924
Zeros	0
Zeros (%)	0.0%
Memory size	2.8 KiB

Quantile statistics

Minimum	1.227316667
5-th percentile	1.95266386
Q1	2.778298246
median	3.981180328
Q3	7.0674
95-th percentile	11.09100109
Maximum	23.51155172
Range	22.28423506
Interquartile range (IQR)	4.289101754

Descriptive statistics

Standard deviation	3.249983511
Coefficient of variation (CV)	0.6306091717
Kurtosis	3.650519708
Mean	5.153720651
Median Absolute Deviation (MAD)	1.553380328
Skewness	1.580632489
Sum	1736.803859
Variance	10.56239282

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2.469578947	1	0.3%
10.95140351	1	0.3%
7.443017544	1	0.3%
3.968016667	1	0.3%
2.97795	1	0.3%
4.356192982	1	0.3%
5.506245614	1	0.3%
2.931148148	1	0.3%
4.441616667	1	0.3%
3.113383333	1	0.3%
4.98455	1	0.3%
7.45195082	1	0.3%
2.743224138	1	0.3%
2.019655738	1	0.3%
8.509192982	1	0.3%
2.763534483	1	0.3%
8.862368421	1	0.3%
2.068816667	1	0.3%
13.7144	1	0.3%
5.859051724	1	0.3%
2.935966667	1	0.3%
3.560561404	1	0.3%
9.8847	1	0.3%
8.782639344	1	0.3%
10.46666038	1	0.3%
Other values (312)	312	92.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1.227316667	1	0.3%
1.386413793	1	0.3%
1.397258621	1	0.3%
1.439035088	1	0.3%
1.482516667	1	0.3%
1.5396	1	0.3%
1.707716667	1	0.3%
1.711086207	1	0.3%
1.743666667	1	0.3%
1.75255	1	0.3%

Value	Count	Frequency (%)
23.51155172	1	0.3%
18.06853333	1	0.3%
17.8042	1	0.3%
16.029	1	0.3%
14.50605172	1	0.3%
13.7144	1	0.3%
13.4831	1	0.3%
12.21401724	1	0.3%
12.17863793	1	0.3%
12.00555	1	0.3%

PM2.5
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct count	337
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5.622708187390472
Minimum	1.456616666666666
Maximum	26.493362068965524
Zeros	0
Zeros (%)	0.0%
Memory size	2.8 KiB

Quantile statistics

Minimum	1.456616667
5-th percentile	2.183604153
Q1	3.096551724
median	4.372482759
Q3	7.611983333
95-th percentile	11.93546848
Maximum	26.49336207
Range	25.0367454
Interquartile range (IQR)	4.515431609

Descriptive statistics

Standard deviation	3.485940383
Coefficient of variation (CV)	0.6199753333
Kurtosis	4.53596597
Mean	5.622708187
Median Absolute Deviation (MAD)	1.622767241
Skewness	1.692645092
Sum	1894.852659
Variance	12.15178035

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
4.330233333	1	0.3%
11.25333333	1	0.3%
5.200862069	1	0.3%
2.858526316	1	0.3%
9.97222807	1	0.3%
3.176147541	1	0.3%
2.175754098	1	0.3%
2.293637931	1	0.3%
1.644192982	1	0.3%
2.743833333	1	0.3%
8.193947368	1	0.3%
4.328934426	1	0.3%
11.48278689	1	0.3%
5.822913793	1	0.3%
3.01022807	1	0.3%
7.530933333	1	0.3%
10.26690164	1	0.3%
3.147783333	1	0.3%
10.84793333	1	0.3%
8.359051724	1	0.3%
8.304448276	1	0.3%
2.480666667	1	0.3%
3.282344262	1	0.3%
7.728086207	1	0.3%
5.012672414	1	0.3%
Other values (312)	312	92.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1.456616667	1	0.3%
1.633258621	1	0.3%
1.644192982	1	0.3%
1.654344828	1	0.3%
1.735033333	1	0.3%
1.772833333	1	0.3%
1.90037931	1	0.3%
1.917283333	1	0.3%
1.95955	1	0.3%
1.9749	1	0.3%

Value	Count	Frequency (%)
26.49336207	1	0.3%
19.62843333	1	0.3%
19.5908	1	0.3%
17.35960345	1	0.3%
15.78189655	1	0.3%
14.5822	1	0.3%
14.49863333	1	0.3%
13.31147541	1	0.3%
13.17775862	1	0.3%
13.01306897	1	0.3%

PM10
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	327
Unique (%)	97.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5.783925816023739
Minimum	1.639
Maximum	28.114
Zeros	0
Zeros (%)	0.0%
Memory size	2.8 KiB

Quantile statistics

Minimum	1.639
5-th percentile	2.319
Q1	3.3
median	4.556
Q3	7.701
95-th percentile	12.1258
Maximum	28.114
Range	26.475
Interquartile range (IQR)	4.401

Descriptive statistics

Standard deviation	3.527657222
Coefficient of variation (CV)	0.6099070655
Kurtosis	5.665066819
Mean	5.783925816
Median Absolute Deviation (MAD)	1.585
Skewness	1.847276733
Sum	1949.183
Variance	12.44436547

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
5.152	2	0.6%
8.224	2	0.6%
6	2	0.6%
3.099	2	0.6%
3.346	2	0.6%
3.487	2	0.6%
2.437	2	0.6%
7.381	2	0.6%
2.373	2	0.6%
3.188	2	0.6%
7.697	1	0.3%
7.773	1	0.3%
8.59	1	0.3%
4.221	1	0.3%
8.285	1	0.3%
6.223	1	0.3%
5.8	1	0.3%
3.499	1	0.3%
11.4	1	0.3%
2.806	1	0.3%
3.014	1	0.3%
9.516	1	0.3%
3.413	1	0.3%
14.254	1	0.3%
4.259	1	0.3%
Other values (302)	302	89.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1.639	1	0.3%
1.786	1	0.3%
1.813	1	0.3%
1.872	1	0.3%
1.928	1	0.3%
1.942	1	0.3%
2.01	1	0.3%
2.052	1	0.3%
2.099	1	0.3%
2.122	1	0.3%

Value	Count	Frequency (%)
28.114	1	0.3%
20.356	1	0.3%
20.173	1	0.3%
17.784	1	0.3%
16.233	1	0.3%
14.772	1	0.3%
14.678	1	0.3%
14.254	1	0.3%
13.498	1	0.3%
13.13	1	0.3%

Temp_int
Real number (ℝ_≥0)

Distinct count	6
Unique (%)	1.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	25.774480712166174
Minimum	24
Maximum	30
Zeros	0
Zeros (%)	0.0%
Memory size	2.8 KiB

Quantile statistics

Minimum	24
5-th percentile	24
Q1	26
median	26
Q3	26
95-th percentile	26
Maximum	30
Range	6
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.8396082812
Coefficient of variation (CV)	0.03257517738
Kurtosis	3.822132035
Mean	25.77448071
Median Absolute Deviation (MAD)	0
Skewness	-0.4344424989
Sum	8686
Variance	0.7049420658

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
26	273	81.0%
24	50	14.8%
27	8	2.4%
28	3	0.9%
29	2	0.6%
30	1	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
24	50	14.8%
26	273	81.0%
27	8	2.4%
28	3	0.9%
29	2	0.6%
30	1	0.3%

Value	Count	Frequency (%)
30	1	0.3%
29	2	0.6%
28	3	0.9%
27	8	2.4%
26	273	81.0%
24	50	14.8%

Humidity_int
Real number (ℝ_≥0)

Distinct count	48
Unique (%)	14.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	50.409495548961424
Minimum	29
Maximum	76
Zeros	0
Zeros (%)	0.0%
Memory size	2.8 KiB

Quantile statistics

Minimum	29
5-th percentile	32
Q1	40
median	49
Q3	59
95-th percentile	75
Maximum	76
Range	47
Interquartile range (IQR)	19

Descriptive statistics

Standard deviation	12.88011221
Coefficient of variation (CV)	0.255509643
Kurtosis	-0.7520158559
Mean	50.40949555
Median Absolute Deviation (MAD)	9
Skewness	0.375430533
Sum	16988
Variance	165.8972905

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
48	15	4.5%
75	15	4.5%
45	15	4.5%
35	12	3.6%
49	11	3.3%
47	11	3.3%
46	11	3.3%
36	11	3.3%
55	11	3.3%
56	11	3.3%
43	11	3.3%
60	10	3.0%
54	10	3.0%
50	9	2.7%
44	9	2.7%
33	8	2.4%
32	8	2.4%
37	8	2.4%
72	8	2.4%
57	8	2.4%
51	8	2.4%
38	7	2.1%
41	7	2.1%
34	7	2.1%
30	7	2.1%
Other values (23)	89	26.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
29	2	0.6%
30	7	2.1%
31	5	1.5%
32	8	2.4%
33	8	2.4%
34	7	2.1%
35	12	3.6%
36	11	3.3%
37	8	2.4%
38	7	2.1%

Value	Count	Frequency (%)
76	4	1.2%
75	15	4.5%
74	6	1.8%
73	4	1.2%
72	8	2.4%
71	2	0.6%
70	4	1.2%
69	5	1.5%
68	2	0.6%
67	1	0.3%

Temp_ext
Real number (ℝ_≥0)

Distinct count	22
Unique (%)	6.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	23.415430267062316
Minimum	14
Maximum	35
Zeros	0
Zeros (%)	0.0%
Memory size	2.8 KiB

Quantile statistics

Minimum	14
5-th percentile	17
Q1	21
median	24
Q3	25
95-th percentile	30.2
Maximum	35
Range	21
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	3.998451993
Coefficient of variation (CV)	0.1707614145
Kurtosis	0.2781135863
Mean	23.41543027
Median Absolute Deviation (MAD)	2
Skewness	0.1909444476
Sum	7891
Variance	15.98761834

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
24	56	16.6%
25	51	15.1%
23	40	11.9%
21	26	7.7%
19	23	6.8%
22	19	5.6%
20	16	4.7%
28	16	4.7%
18	12	3.6%
26	10	3.0%
29	10	3.0%
17	10	3.0%
27	9	2.7%
15	8	2.4%
30	8	2.4%
33	5	1.5%
31	4	1.2%
32	4	1.2%
16	3	0.9%
14	3	0.9%
34	3	0.9%
35	1	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
14	3	0.9%
15	8	2.4%
16	3	0.9%
17	10	3.0%
18	12	3.6%
19	23	6.8%
20	16	4.7%
21	26	7.7%
22	19	5.6%
23	40	11.9%

Value	Count	Frequency (%)
35	1	0.3%
34	3	0.9%
33	5	1.5%
32	4	1.2%
31	4	1.2%
30	8	2.4%
29	10	3.0%
28	16	4.7%
27	9	2.7%
26	10	3.0%

Humidity_ext
Real number (ℝ_≥0)

Distinct count	60
Unique (%)	17.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	48.682492581602375
Minimum	20
Maximum	85
Zeros	0
Zeros (%)	0.0%
Memory size	2.8 KiB

Quantile statistics

Minimum	20
5-th percentile	27
Q1	38
median	49
Q3	57
95-th percentile	80
Maximum	85
Range	65
Interquartile range (IQR)	19

Descriptive statistics

Standard deviation	14.43097556
Coefficient of variation (CV)	0.2964304989
Kurtosis	-0.01174342266
Mean	48.68249258
Median Absolute Deviation (MAD)	10
Skewness	0.401885001
Sum	16406
Variance	208.2530557

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
38	18	5.3%
51	15	4.5%
49	14	4.2%
50	14	4.2%
46	14	4.2%
53	13	3.9%
57	13	3.9%
56	10	3.0%
31	10	3.0%
48	9	2.7%
52	9	2.7%
37	9	2.7%
60	8	2.4%
55	8	2.4%
59	8	2.4%
30	8	2.4%
32	7	2.1%
29	7	2.1%
45	7	2.1%
36	7	2.1%
47	7	2.1%
54	7	2.1%
43	6	1.8%
33	5	1.5%
39	5	1.5%
Other values (35)	99	29.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
20	2	0.6%
21	3	0.9%
22	1	0.3%
23	2	0.6%
24	3	0.9%
25	2	0.6%
26	3	0.9%
27	2	0.6%
28	3	0.9%
29	7	2.1%

Value	Count	Frequency (%)
85	4	1.2%
84	3	0.9%
83	3	0.9%
82	2	0.6%
81	2	0.6%
80	4	1.2%
78	2	0.6%
74	3	0.9%
73	1	0.3%
70	1	0.3%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

First rows

	Time	Ozone	H2S	VOC	CO2	PM1	PM2.5	PM10	Temp_int	Humidity_int	Temp_ext	Humidity_ext
0	2020-05-26 08:00:00	0.21	0.00080	0.268	471	13.714400	14.582200	14.678	24	46	23	48
1	2020-05-26 09:00:00	0.21	0.00027	0.763	512	5.331483	5.711433	5.800	24	47	23	50
2	2020-05-26 10:00:00	0.22	0.00017	0.487	553	5.477121	5.907345	6.047	24	49	24	52
3	2020-05-26 11:00:00	0.24	0.00000	0.417	581	6.988000	7.530933	7.701	24	50	24	52
4	2020-05-26 12:00:00	0.24	0.00000	0.328	620	7.369931	7.884414	4.720	24	50	24	51
5	2020-05-26 13:00:00	0.23	0.00000	0.370	650	7.917000	8.501150	4.189	24	50	24	51
6	2020-05-26 14:00:00	0.22	0.00000	0.355	715	8.410052	9.097793	5.741	24	51	24	51
7	2020-05-26 15:00:00	0.23	0.00000	0.356	762	8.445200	9.053983	9.196	24	51	24	49
8	2020-05-26 16:00:00	0.21	0.00000	0.344	773	7.759017	8.304448	8.425	24	51	25	48
9	2020-05-26 17:00:00	0.21	0.00000	0.328	771	7.597217	8.147317	8.285	24	53	25	49

Last rows

	Time	Ozone	H2S	VOC	CO2	PM1	PM2.5	PM10	Temp_int	Humidity_int	Temp_ext	Humidity_ext
327	2020-06-08 23:00:00	0.33	0.00000	0.145	359	3.605383	3.968417	4.153	26	30	21	40
328	2020-06-09 00:00:00	0.33	0.00021	0.149	366	3.457000	3.761276	3.884	26	30	21	42
329	2020-06-09 01:00:00	0.33	0.00002	0.157	380	4.357217	4.730833	4.869	26	31	20	46
330	2020-06-09 02:00:00	0.34	0.00000	0.162	392	5.312569	5.823983	6.052	26	32	20	48
331	2020-06-09 03:00:00	0.34	0.00000	0.168	395	5.742717	6.261150	6.475	26	33	19	50
332	2020-06-09 04:00:00	0.33	0.00000	0.171	401	5.747500	6.248207	6.439	26	33	19	51
333	2020-06-09 05:00:00	0.32	0.00000	0.173	421	5.981517	6.525333	6.751	26	34	19	53
334	2020-06-09 06:00:00	0.31	0.00012	0.186	435	5.859052	6.354155	6.531	26	36	20	54
335	2020-06-09 07:00:00	0.36	0.00000	0.184	394	6.573183	7.188367	7.457	26	38	21	50
336	2020-06-09 08:00:00	0.38	0.00000	0.185	391	6.225521	6.950750	7.335	26	38	22	47

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows